package com.kehutong.charge.vo;

import com.alibaba.excel.annotation.ExcelIgnoreUnannotated;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.*;
import org.apache.poi.ss.usermodel.HorizontalAlignment;

/**
 * @description: 抄表模板导出
 * @author: jian Ye
 * @create: 2021/8/23
 **/
@ExcelIgnoreUnannotated
@HeadRowHeight(50)
@HeadStyle(horizontalAlignment = HorizontalAlignment.LEFT)
@ContentFontStyle(fontHeightInPoints = 12)
@HeadFontStyle(fontHeightInPoints = 12,color = 10,bold = false)
@ColumnWidth(15)
public class MeterManageTemplateExcelVO {

    protected final static String BIG_TITLE =
            "填写须知（本行和表头行勿删除）：\n" +
            "(1)以下红色字体为必填，黑色字体为选填；\n" +
            "(2)本次读数中只需填写抄表的数值，无需填写单位；\n";



    @ColumnWidth(30)
    @ExcelProperty({BIG_TITLE,"仪表编号"})
    private String meterNo;

    @ExcelProperty({BIG_TITLE,"仪表类型"})
    private String meterTypeName;

    @ExcelProperty({BIG_TITLE,"仪表分类"})
    private String meterClassifyName;

    @ExcelProperty({BIG_TITLE,"项目/小区名称"})
    private String communityName;

    @ExcelProperty({BIG_TITLE,"楼栋"})
    private String buildName;

    @HeadFontStyle(fontHeightInPoints = 12,color = 8,bold = false)
    @ExcelProperty({BIG_TITLE,"单元"})
    private String unitName;

    @ExcelProperty({BIG_TITLE,"楼层"})
    private String floorName;

    @ExcelProperty({BIG_TITLE,"房号"})
    private String houseName;

    private String houseNo;


    public String getMeterNo() {
        return meterNo;
    }

    public void setMeterNo(String meterNo) {
        this.meterNo = meterNo;
    }

    public String getMeterTypeName() {
        return meterTypeName;
    }

    public void setMeterTypeName(String meterTypeName) {
        this.meterTypeName = meterTypeName;
    }

    public String getMeterClassifyName() {
        return meterClassifyName;
    }

    public void setMeterClassifyName(String meterClassifyName) {
        this.meterClassifyName = meterClassifyName;
    }

    public String getCommunityName() {
        return communityName;
    }

    public void setCommunityName(String communityName) {
        this.communityName = communityName;
    }

    public String getBuildName() {
        return buildName;
    }

    public void setBuildName(String buildName) {
        this.buildName = buildName;
    }

    public String getUnitName() {
        return unitName;
    }

    public void setUnitName(String unitName) {
        this.unitName = unitName;
    }

    public String getHouseNo() {
        return houseNo;
    }

    public void setHouseNo(String houseNo) {
        this.houseNo = houseNo;
    }


    public String getFloorName() {
        return floorName;
    }

    public void setFloorName(String floorName) {
        this.floorName = floorName;
    }

    public String getHouseName() {
        return houseName;
    }

    public void setHouseName(String houseName) {
        this.houseName = houseName;
    }
}
